
CREATE TABLE KLIENT (
    KlientID INTEGER NOT NULL primary key
        generated always as identity
        (start with 1, increment by 1), 
    KlientNaam VARCHAR(100), 
    Ouderdom INTEGER, 
    Poskode VARCHAR(4)
);


INSERT INTO KLIENT (KlientNaam, Ouderdom, Poskode) VALUES
('John Dlamini', 15, '0140'),
('Leo Sithole', 22, '1240'),
('Steve Jacobs', 21, '0125'),
('Pat Khumalo', 23, '1251'),
('Sipho Nkosi', 14, '1240'),
('Musi Mahlangu', 38, '0120'),
('Sibongile Ngcobo', 25, '1240'),
('Lindewe Khoza', 18, '1500'),
('Johannes Botha', 33, '1600'),
('Bongani Radebe', 32, '1500'),
('Caleb Pillay', 31, '1600'),
('Anna Mthembu', 45, '0180'),
('Thabo Baloyi', 37, '0158'),
('Mpho Sithole', 14, '1250'),
('Peter Zwane', 30, '1240'),
('Maria Nkosi', 21, '0152'),
('Samuel Naidoo', 16, '1600'),
('Patricia Williams', 17, '0120'),
('Joseph Mkhize', 31, '0140'),
('Zenele Ndlovu', 42, '0140'),
('Daniel Dlamini', 45, '1500'),
('Jabu Chauke', 35, '1600'),
('Willem du Plessis', 23, '1600'),
('Jan Venter', 31, '1250'),
('Linda Gumede', 13, '0180'),
('Zandile Methembu', 22, '1600'),
('Robert Maseko', 16, '1250'),
('Cynthia Fourie', 18, '1500'),
('Nomsa Baloyi', 14, '1240'),
('Bongiwe Mokoena', 25, '0160'),
('Al Naidoo', 23, '0127'),
('Phindile Ntuli', 15, '0180'),
('Bianca Abrahams', 22, '0160'),
('Freddy Chetty', 17, '0160'),
('Moses Sibisi', 31, '0121'),
('Vusi Khumalo', 13, '1240'),
('Hendrick van Zyl', 27, '0180'),
('Lucky Shabangu', 16, '0123');



CREATE TABLE BERADER (
    BeraderID INTEGER NOT NULL primary key
        generated always as identity
        (start with 1, increment by 1), 
    BeraderNaam VARCHAR(100), 
    Tarief DOUBLE
);


INSERT INTO BERADER (BeraderNaam, Tarief) VALUES
('Vernon Booysen', 150),
('Matthew Kunene', 180),
('Heather Modise', 150),
('Siyanda Mabuza', 120),
('Joshua Hendricks', 120),
('Thabo Matlala', 150),
('Michael Mabasa', 180),
('Sibu Ndou', 140),
('Xolani Nzimande', 150),
('Linda September', 120),
('Patrick Ntuli', 0);



CREATE TABLE AFSPRAAK (
  AfspraakID INTEGER NOT NULL primary key
        generated always as identity
        (start with 1, increment by 1), 
  KlientID INTEGER,
  BeraderID INTEGER,
  AfspraakDatum DATE,
  Plek VARCHAR(25)
);


INSERT INTO AFSPRAAK (KlientID, BeraderID, AfspraakDatum, Plek) VALUES
(1,2,'2020-10-14','Bergsig'),
(3,2,'2020-10-14','Bergsig'),
(11,2,'2020-10-14','Bergsig'),
(34,2,'2020-10-14','Bergsig'),
(2,5,'2020-10-14','Greenside'),
(5,5,'2020-10-14','Greenside'),
(24,5,'2020-10-14','Greenside'),
(29,5,'2020-10-14','Greenside'),
(36,5,'2020-10-14','Greenside'),
(19,1,'2020-10-15','Bergsig'),
(37,1,'2020-10-15','Bergsig'),
(38,1,'2020-10-15','Bergsig'),
(12,2,'2020-10-15','Bergsig'),
(18,2,'2020-10-15','Bergsig'),
(34,2,'2020-10-15','Bergsig'),
(4,7,'2020-10-15','Greenside'),
(15,7,'2020-10-15','Greenside'),
(27,7,'2020-10-15','Greenside'),
(20,2,'2020-10-16','Bergsig'),
(33,2,'2020-10-16','Bergsig'),
(35,2,'2020-10-16','Bergsig'),
(8,4,'2020-10-16','Panorama'),
(2,5,'2020-10-16','Greenside'),
(25,2,'2020-10-19','Bergsig'),
(30,2,'2020-10-19','Bergsig'),
(1,2,'2020-10-20','Bergsig'),
(12,2,'2020-10-20','Bergsig'),
(18,2,'2020-10-20','Bergsig'),
(8,4,'2020-10-20','Panorama'),
(17,4,'2020-10-20','Panorama'),
(23,4,'2020-10-20','Panorama'),
(24,4,'2020-10-20','Panorama'),
(24,5,'2020-10-20','Greenside'),
(29,5,'2020-10-20','Greenside'),
(14,6,'2020-10-20','Greenside'),
(4,7,'2020-10-20','Greenside'),
(1,1,'2020-10-21','Bergsig'),
(3,1,'2020-10-21','Bergsig'),
(6,1,'2020-10-21','Bergsig'),
(12,1,'2020-10-21','Bergsig'),
(19,1,'2020-10-21','Bergsig'),
(9,8,'2020-10-22','Panorama'),
(19,1,'2020-10-23','Bergsig'),
(25,2,'2020-10-23','Bergsig'),
(30,2,'2020-10-23','Bergsig'),
(8,4,'2020-10-23','Panorama'),
(22,4,'2020-10-23','Panorama'),
(9,8,'2020-10-23','Panorama'),
(21,8,'2020-10-23','Panorama'),
(28,8,'2020-10-23','Panorama'),
(18,2,'2020-10-26','Bergsig'),
(30,2,'2020-10-26','Bergsig'),
(8,4,'2020-10-26','Panorama'),
(17,4,'2020-10-26','Panorama'),
(2,5,'2020-10-26','Greenside'),
(24,5,'2020-10-26','Greenside'),
(29,5,'2020-10-26','Greenside'),
(4,7,'2020-10-26','Greenside'),
(15,7,'2020-10-26','Greenside'),
(27,7,'2020-10-26','Greenside'),
(10,10,'2020-10-26','Panorama'),
(22,10,'2020-10-26','Panorama'),
(6,1,'2020-10-27','Bergsig'),
(12,1,'2020-10-27','Bergsig'),
(19,1,'2020-10-27','Bergsig'),
(32,1,'2020-10-27','Bergsig'),
(1,3,'2020-10-27','Bergsig'),
(31,3,'2020-10-27','Bergsig'),
(14,6,'2020-10-27','Greenside'),
(29,6,'2020-10-27','Greenside'),
(4,7,'2020-10-27','Greenside'),
(15,7,'2020-10-27','Greenside'),
(21,8,'2020-10-27','Panorama'),
(10,10,'2020-10-27','Panorama'),
(22,10,'2020-10-27','Panorama'),
(31,3,'2020-10-28','Bergsig');